package pers.zxk.jlytnews.dao;

import pers.zxk.jlytnews.entity.FoodMenu;
import pers.zxk.jlytnews.entity.FoodMenuWithFood;
import pers.zxk.jlytnews.entity.FoodWithType;

import java.sql.SQLException;
import java.util.List;

public interface FoodMenuDao {
    public boolean addFoodMenu(int foodId, String date, String time, String description, String remarks) throws SQLException, ClassNotFoundException;//添加菜谱

    public boolean delFoodMenu(int id) throws SQLException, ClassNotFoundException;//通过id删除菜谱

    public boolean updateFoodMenu(int id, int foodId, String date, String time, String description, String remarks) throws SQLException, ClassNotFoundException;//更新

    public List<FoodMenuWithFood> getFoodMenu(String date) throws SQLException, ClassNotFoundException;//通过日期和时间查询

    public List<FoodMenuWithFood> getFoodMenu(String date, String time) throws SQLException, ClassNotFoundException;//通过日期和时间查询
}
